Elements and Performance Criteria
- Confirm the database design
- Review database design documentation, including data structures, queries, reports, and user interfaces to identify organisational data management, access and security requirements
- Evaluate sufficiency of database access and security feature design to organisational data security plan
- Document and rectify inconsistencies between database design and organisational data security plan
- Create a prototype database
- Develop prototype database according to database design
- Populate database tables with current organisational data to test database implementation
- Write conversion programs to import data from existing systems in accordance with scope specified in database design documentation
- Assess functionality of prototype with user, including identifying errors in program code and modifying user interfaces and reports
- Incorporate feedback from user into prototype
- Obtain user approval of prototype
- Deploy the database
- Develop implementation plan for database aligned with user acceptance criteria
- Install database management system software on network in accordance with implementation plan
- Populate database tables with organisational data in accordance with implementation plan
- Implement security and access controls in accordance with database design documentation and implementation plan
- Test and document database output and security controls, and record results in accordance with database design documentation
- Evaluate the database
- Review the database against user acceptance criteria and rectify discrepancies
- Complete database documentation in accordance with user acceptance criteria
- Identify and document user training requirements from database design documentation
- Seek and secure user acceptance of database in accordance with user acceptance criteria